package thefirst.support.model;

import java.sql.SQLException;
import java.util.List;

public interface NoticeDao {
	public int writeNotice(NoticeVO nvo) throws SQLException;
	public NoticeVO showNoticeInfoNoHits(int no) throws SQLException;
	public void deleteNotice(int no) throws SQLException;
	public int updateNotice(NoticeVO nvo) throws SQLException;
	public List<NoticeVO> getNoticeList(String pageNo) throws SQLException;
	public int totalNoticeContent() throws SQLException;
	public int updateHits(int no) throws SQLException;
	public int updateNoticeNoFile(int no) throws SQLException;
	public List<NoticeVO> getNoticeListForLeft() throws SQLException;
	public List<NoticeVO> findNoticeListByTitle(NoticeSearchVO nsvo) throws SQLException;
	public List<NoticeVO> findNoticeListByContent(NoticeSearchVO nsvo) throws SQLException;
	public int totalNoticeContentByTitle(String title) throws SQLException;
	public int totalNoticeContentByContent(String content) throws SQLException;
}
